Connections FAQs
Frequently asked questions for the Connections guide.
What ODBC driver should I use?
The required driver depends on the target database. For example, use 'ODBC Driver 17 for SQL Server' for Microsoft SQL, or 'MySQL ODBC 8.0 Driver' for MySQL. Ensure the driver is installed on the system running the IDE.
Can I use Windows Authentication for MSSQL?
Yes. In the connection settings for MSSQL, you can choose "Windows Authentication" as the authentication type instead of SQL Authentication. Make sure the IDE runtime has access rights to authenticate via Windows.
What is the difference between SID and Service Name in Oracle?
SID identifies a specific database instance, while the Service Name can point to multiple instances for load balancing. Use what matches your environment's connection configuration.
How to access an RFC function module in SAP?
You need to enter the exact name of the function module (e.g., 'Z_GET_ORDER_DATA') and define its input and output parameters in the connection settings. The IDE uses this module to retrieve or send data.
What HTTP methods are supported in REST connections?
Synergy IDE supports common HTTP methods such as GET, POST, PUT, and DELETE. You can configure the method depending on the REST API's require